package com.ebt.m.data.db;

/**
 * 产品表
 *
 * @author Michael.li
 */
public final class Product implements EbtBaseColumns {
    /**
     * 表名
     */
    public static final String TABLE_NAME = "cProduct";
    /** 默认排序方式 */
    // public static final String DEFAULT_SORT_ORDER = "d_isSale DESC";

    /**
     * 主键 Type: INTEGER
     **/
    public static final String ID = "Id";
    /**
     * 名称 Type: VARCHAR(100)
     **/
    public static final String COLUMN_PRODUCTNAME = "ProductName";
    /**
     * 简称 Type: VARCHAR(100)
     **/
    public static final String COLUMN_SHORTNAME = "ShortName";
    /**
     * 公司ID Type: INTEGER
     **/
    public static final String COLUMN_COMPANYID = "CompanyId";
    /**
     * 类别ID Type: INTEGER
     **/
    public static final String COLUMN_PRODUCTCATEGORYID = "ProductCategoryId";
    /**
     * 类别 Type: String
     **/
    public static final String COLUMN_PRODUCTCATEGORY= "CategoryName";
    /**
     * 公司名 Type: String
     **/
    public static final String COLUMN_COMPANYNAME= "companyName";
    /**
     * 公司名short Type: String
     **/
    public static final String COLUMN_COMPANYSHORT= "companyShortName";
    /**
     * 是否销售 Type: INTEGER
     **/
    public static final String COLUMN_D_ISSALE = "d_isSale";
    /**
     * 是否主险 Type: INTEGER
     **/
    public static final String COLUMN_D_ISMAJOR = "d_isMajor";
    /**
     * 是否分红 Type: INTEGER
     **/
    public static final String COLUMN_D_FENHONGXINGZHI = "d_fenHongXingZhi";
    /**
     * 投保最小年龄 Type: INTEGER
     **/
    public static final String COLUMN_D_TOUBAONIANLING_MIN = "d_touBaoNianLing_min";
    /**
     * 投保最大年龄 Type: INTEGER
     **/
    public static final String COLUMN_D_TOUBAONIANLING_MAX = "d_touBaoNianLing_max";
    /**
     * 产品缩略图 Type: VARCHAR(100)
     **/
    public static final String COLUMN_D_PICFILE = "d_picFile";
    /**
     * 保障期间 Type: VARCHAR(1000)
     **/
    public static final String COLUMN_D_BAOZHANGQIJIAN = "d_baoZhangQiJian";
    /**
     * 缴费期间 Type: VARCHAR(1000)
     **/
    public static final String COLUMN_D_JIAOFEIQIJIAN = "d_jiaoFeiQiJian";
    /**
     * 销售日期 Type: DATETIME
     **/
    public static final String COLUMN_D_STARTSELLINGDATE = "d_startSellingDate";

    /**
     * 停售日期 Type: DATETIME
     **/
    public static final String COLUMN_D_STOPSELLINGDATE = "d_stopSellingDate";

    /**
     * 销售渠道 Type: DATETIME
     **/
    public static final String COLUMN_D_SALECHANNEL = "d_SaleChannelIDs";
    /**
     * 数据版本号 Type: INTEGER
     **/
    public static final String COLUMN_D_PRODUCTVERSION = "d_productVersion";
    /**
     * 资源版本号 Type: INTEGER
     **/
    public static final String COLUMN_D_RESOURCEVERSION = "d_resourceVersion";
    /**
     * 描述 Type: VARCHAR(2000)
     **/
    public static final String COLUMN_DESCRIPTION = "Description";
    /**
     * 是否离线产品 Type: INTEGER
     **/
    public static final String COLUMN_ISLOCAL = "IsLocal";
    /**
     * 演示模式下是否显示 Type: INTEGER
     **/
    public static final String COLUMN_ISSHOW = "IsShow";
    /**
     * 本地数据版本号 Type: INTEGER
     **/
    public static final String COLUMN_LOCALPRODUCTVERSION = "LocalProductVersion";
    /**
     * 本地数据更新成功标记 Type: INTEGER
     **/
    public static final String COLUMN_LOCALPRODUCTSUCCESS = "LocalProductSuccess";
    /**
     * 本地数据更新时间 Type: DATETIME
     **/
    public static final String COLUMN_LOCALPRODUCTUPDATETIME = "LocalProductUpdateTime";
    /**
     * 本地资源版本号 Type: INTEGER
     **/
    public static final String COLUMN_LOCALRESOURCEVERSION = "LocalResourceVersion";
    /**
     * 本地资源更新成功标记 Type: INTEGER
     **/
    public static final String COLUMN_LOCALRESOURCESUCCESS = "LocalResourceSuccess";
    /**
     * 本地资源更新时间 Type: DATETIME
     **/
    public static final String COLUMN_LOCALRESOURCEUPDATETIME = "LocalResourceUpdateTime";

    /** 是否在计划书中 Type: INTEGER **/
    // public static final String COLUMN_ISPROPOSALED = "IsProposaled";

    public static final String COLUMN_CompositionProperty = "CompositionProperty";

    /**
     * 性别 0无限制 1女 2男
     */
    public static final String COLUMN_ACCSEX = "AccSex";

    /**
     * 合同属性
     */
    public static final String COLUMN_ContractProperty = "ContractProperty";
    /**
     * 职业类别
     */
    public static final String COLUMN_ACCOCCUPATION = "AccOccupation";

    /**
     * 计划书渠道Type: VARCHAR
     **/
    public static final String COLUMN_INSURERPROPOSALSYSID = "InsurerProposalSysID";
    /**
     * 扩充字段 Type: VARCHAR
     **/
    public static final String COLUMN_EXTENDJSON = "ExtendJSON";
    /**
     * 创建日期 Type: DATETIME
     **/
    public static final String CREATE_TIME = "CreateTime";

    public static final String CATEGORYNAME = "categoryName";
    public static final String CATEGORYID = "categoryId";
    /**
     * 创建日期 Type: VARCHAR(50)
     */
    public static final String COLUMN_LISTORDER = "ListOrder";
    /**
     * 更新标志: INTEGER
     **/
    public static final String COLUMN_UPDATEFLAG = "UpdateFlag";
    /**
     * 更新标志: INTEGER
     **/
    public static final String COLUMN_CUSTOMER_ID = "CUSTOMER_UUID";
    /* 是否收藏标志0否 */
    public static final String COLUMN_IS_FAV = "isFav";
    public static final String COLUMN_FAV_CREATE_TIME = "favCreateTime";
    /* 是否收藏标志0否 */
    public static final String COLUMN_B_COUNT = "b_count";
    public static final String COLUMN_B_TIME = "b_time";
    /*MODELMAP-产品特色用*/
    public static final String COLUMN_MODEL_MAP = "ModelMap";
    public static final String COLUMN_PRODUCTWEIGHT = "ProductWeight";
    public static final String COLUMN_RECORDTIME = "RecordTime";
    public static final String COLUMN_Weight = "Weight";

    public static final String COLUMN_ISADDCOMPARE = "isAddCompare";
}
